class UsersAddProfileFields < ActiveRecord::Migration
  def self.up
    query = <<-_SQL
      ALTER TABLE `users` ADD `first_name` TINYTEXT NULL ,
      ADD `last_name` TINYTEXT NULL ,
      ADD `phone` VARCHAR( 100 ) NULL ,
      ADD `im` VARCHAR( 100 ) NULL ,
      ADD `description` TEXT NULL ;
    _SQL
    
    execute query
  end

  def self.down
    query = <<-_SQL
      ALTER TABLE `users` DROP `first_name` ,
      DROP `last_name` ,
      DROP `phone` ,
      DROP `im` ,
      DROP `description`;
    _SQL
    
    execute query
  end
end
